SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519383 LIMIT 1 [ RunTime:0.000700s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519383 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319524,822495,329206,307166,55857,1017574,619343,48794,805152,438552,972068,986125,771377,562964,845617,120273,212566,658428,484050,469037,343170,7810,639284,893479,1024317,628211,374186,32348,424728,129104,396731,487931,594977,653092,424394,318124,411969,526338,700038,645567,709113,514401,365819,246647,783718,6470,1024094,133123,352907,27411,319079,560021,313871,63937,514657,762219,832268,790083,292654,639841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]