SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511917 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511917 [ RunTime:0.002660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267489,235344,1001730,214412,955666,949052,317287,806112,736965,1005012,874495,511462,982354,743673,561862,762268,699080,339089,299871,538760,745963,644119,988485,104171,752078,697985,389010,554774,455982,512976,960675,363480,15408,56585,921976,684122,820106,195952,131478,172523,928102,85723,531901,115604,788803,179367,438298,465507,539666,28647,65309,417351,596312,912748,729250,452306,476908,348994,142445,194779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]