SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38111 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38111 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (746254,487940,297461,591928,669904,778321,255721,536754,88018,587042,985000,16434,1012149,52571,971513,365862,82048,793354,893067,649116,174968,380078,29961,889099,468731,580647,1020117,432706,901877,380047,988301,267066,353497,856310,771451,553014,373076,782780,699362,888573,311810,933039,948937,846450,1002326,795023,804025,534856,820513,569851,173592,400301,208992,198856,162089,794615,629503,378492,646774,448878) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004060s ]