SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001704s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 670416 LIMIT 1 [ RunTime:0.001317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 670416 [ RunTime:0.001847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402277,266003,516878,638575,528159,962911,334254,200870,408502,277261,320059,16500,629827,852367,652161,1035975,572422,829539,315188,426160,1003078,32073,190482,1008233,874162,265636,942935,105175,273006,6396,444580,542112,707977,37472,986674,523967,552048,256400,47835,136568,325410,1043484,564161,821814,745771,710092,48773,169134,343812,151092,935010,647779,399816,29188,357417,671325,185252,111853,506072,501117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 670416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 670416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000727s ]