SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510988 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510988 [ RunTime:0.003200s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336459,388945,826534,189723,660306,1039484,180147,697246,2098,962617,874623,1042133,883411,1001800,72655,951425,719159,127940,1021022,524688,251546,286201,418483,436692,126036,799303,282735,693167,78210,482671,584670,697724,814480,1031933,205502,1037404,228190,14417,478524,421794,450053,126435,392487,219726,767395,150476,740767,730058,306739,934901,77167,479416,839318,1035820,390514,345573,11585,739871,175816,386004) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000778s ]