SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452843 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452843 [ RunTime:0.003076s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575348,707304,129828,721111,542212,514061,568468,837630,571795,804125,791703,250740,677725,954400,694560,276626,933517,80484,601234,880346,610952,648176,5211,793924,625859,168999,367350,15482,236396,480383,1005645,335550,137472,849389,833143,84650,771921,29066,800293,875134,499762,584362,55626,352818,1010782,947308,548367,996670,632973,793634,265066,867362,64703,161034,43399,15704,561509,375914,918932,917528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]