SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354044 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354044 [ RunTime:0.002820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (296423,567021,366572,408117,977311,154254,39649,871848,332042,66140,514751,489094,405195,346006,863967,716797,32276,974543,700046,573875,344006,286291,431343,310851,594109,297933,380684,820320,1038495,485321,437707,68121,198897,373095,948986,731389,980234,667159,1020093,449130,621676,571445,835105,716777,954344,294790,665870,965566,87527,1021742,891485,966882,113898,542319,251166,451065,815089,638299,371501,332212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001750s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354044 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354044 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]