SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10668 LIMIT 1 [ RunTime:0.001686s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10668 [ RunTime:0.005817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433861,337828,991736,78562,737282,182479,686956,1004807,391911,41853,334236,758274,234728,956042,393025,835974,116355,29479,8764,740757,338376,370249,968025,214184,75549,619426,201852,366186,47001,892368,762464,509400,813001,495910,1014595,803035,371274,423422,399421,862089,67768,243272,933778,890325,836923,199077,184188,220152,125594,1041728,227293,84457,578026,150135,355297,725735,369834,428245,37114,286022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001621s ]