SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445415 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445415 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398180,341804,990454,433246,40545,647728,964282,930725,815290,568119,542990,269249,839652,716422,984505,62725,759908,774153,148942,484494,556351,336627,45951,302152,1027525,901849,740011,708201,199424,610047,233938,741863,820902,597802,964203,1004293,463936,96901,351688,622962,320031,392986,308175,949214,264540,264047,370264,36624,62650,326307,277760,828288,132069,86317,907947,200362,91429,287064,751484,149071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000901s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]