SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43111 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43111 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (899452,443503,740333,166740,29413,606446,912080,578455,288322,401382,510095,562321,369223,505,687235,384145,1013695,460342,967213,359539,42893,275946,781394,48750,526522,802708,775067,439362,303547,907039,964980,901158,103141,550032,334563,995136,77143,494195,729780,798461,492851,1027102,461534,21368,873573,522811,579639,607591,955987,264201,196180,313914,231646,99296,5612,708828,1028351,216736,408994,126373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]