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` = 44843 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44843 [ RunTime:0.004431s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12900,372053,871650,627887,700584,1008720,889436,392628,192358,734487,73269,336942,229673,1008419,378279,263662,46140,912744,614166,955579,337418,341849,245288,698097,623168,91,987371,1018024,45223,369764,637064,32493,310700,364925,71963,773926,1019837,530057,110112,94692,675873,393997,866448,127539,893840,208082,8362,351135,127387,247559,578208,1031106,433662,60818,10637,727143,44310,944106,1029701,716018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005903s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]