SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545138 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545138 [ RunTime:0.001878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (935991,741623,759545,896518,1038516,23339,329041,140781,1032603,201273,326081,244073,685003,999763,288492,174169,775218,401665,340617,902732,351321,734515,521555,505015,886459,1043188,287726,47556,286996,644215,490312,68845,996543,824472,50717,625775,243826,54052,596305,821506,981016,906689,287260,99142,538507,1047158,510546,200430,43776,987811,759405,452433,795568,64868,980024,618944,684753,816481,279086,593832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000400s ]