SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002980s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 203208 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 203208 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (773450,88426,888394,466873,476731,520826,292320,715941,312372,155168,940430,491064,955906,991008,166883,128336,313678,84970,569437,905723,303814,358691,364828,310506,650505,156641,342221,90565,22322,780828,919726,131771,307707,726297,899540,669819,322328,212817,407393,908551,821777,344973,626386,362974,767468,96272,401643,24452,766078,699233,601122,153202,932352,42265,895283,562606,516406,95835,198640,448543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 203208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 203208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]