SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 124012 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 124012 [ RunTime:0.001662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (256003,922142,594696,200893,261112,763363,825165,114803,911040,414195,1030527,132587,977496,53065,776887,643033,727615,462273,72917,363135,11618,754237,356811,226236,638098,47245,998144,270084,112971,427361,529934,569571,228413,269818,522667,749740,657498,588502,330775,969840,910639,234109,44373,601653,118946,619500,550226,719831,299813,1043685,135605,755867,184864,626612,199528,789208,50952,723133,831643,783683) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 124012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 124012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]