SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004786s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500291 LIMIT 1 [ RunTime:0.001776s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500291 [ RunTime:0.003150s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398384,96132,16270,718207,12192,450482,303136,764707,465842,645581,880209,226203,889811,422782,406548,852079,896853,590141,976451,865030,1007212,727291,426723,516771,526516,760367,73401,750527,510751,317299,500526,978158,259819,721178,450080,79577,844019,802479,766141,763226,365643,758412,928432,40579,607597,53973,790316,74262,702395,809227,575457,789520,781736,998223,273483,389234,696868,412383,1008060,877267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001801s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]