SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000931s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529683 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529683 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (605277,647545,702822,733373,514763,327270,65788,564127,1036039,823192,584551,578548,7116,192050,508830,571440,141734,6422,1008725,645237,9207,827864,318114,999059,494663,906444,461036,418210,438034,1000585,97939,70809,768899,818686,430909,757869,750396,115522,24525,905493,532192,424180,782982,899916,792215,849008,96268,557188,517712,442345,932595,262488,912478,811153,829804,1043806,159971,570018,287990,171533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]