SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 175581 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 175581 [ RunTime:0.001985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (878785,405588,463938,510847,739669,240916,495741,820760,485213,756718,116496,564706,292664,282199,243529,731508,670261,103389,376779,670106,492942,474976,513392,902058,402186,1042629,284401,93171,427133,487568,164643,394617,261878,848536,191349,153027,982948,325767,281749,14577,417425,132032,736003,18090,237531,211557,695628,963450,992817,70619,648698,427793,443087,114537,746886,382897,1030475,949232,339418,252921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 175581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 175581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]