SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410782 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410782 [ RunTime:0.001929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (817838,921615,296453,834008,461890,842468,897833,177242,28529,785179,901468,508294,768716,848534,953869,805184,990415,202196,745349,1039263,799936,1019667,397915,1010985,750275,482042,44435,662548,1042991,936611,962760,5250,259981,462185,948119,646932,175924,923220,509945,354385,392346,642087,671591,147189,153255,411915,739401,36867,143608,332137,271636,613746,875767,913451,243698,388455,604876,50923,93519,630827) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410782 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410782 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]