SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028148 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028148 [ RunTime:0.003876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497524,665399,301222,923999,951395,984283,216962,627301,623271,212721,622147,157566,15562,843203,146721,115617,812097,961124,587519,890575,820670,478810,77481,1005210,611215,428053,905679,114185,194415,993950,467639,949893,333418,69902,308987,281288,69054,452295,546999,251766,80304,974750,412705,166448,62996,680287,1036152,1037259,72905,794582,1017029,875272,518502,451433,944983,767353,602057,171202,547725,797644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000769s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]