SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154609 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154609 [ RunTime:0.001744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113146,567621,723311,447064,23605,441208,958653,843569,750309,504081,935525,85603,220698,427301,745749,812612,1813,160320,760542,896166,822684,443493,889580,152877,999334,932318,92420,257252,51272,753962,732221,553902,513640,78847,802741,168756,307747,95042,236315,1786,705224,257334,580042,599939,422401,199807,722039,613686,831564,933706,909602,311200,221237,431876,368993,5803,697349,678459,447975,739620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154609 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154609 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]