SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506439 LIMIT 1 [ RunTime:0.000538s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506439 [ RunTime:0.003596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703105,388293,430517,504500,1003329,342581,233737,712426,384978,1036309,222542,80849,601165,763673,820881,814415,978525,501976,159702,401444,798930,622437,686857,595619,308631,625029,679141,610107,533553,532140,954773,389546,971884,649865,295761,938405,296636,524244,130976,492308,806399,838812,208394,411434,735836,741886,488896,689308,760955,750035,95143,88689,742306,537940,847805,1038754,886673,305308,153389,623063) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002802s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506439 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506439 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000830s ]