SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526682 LIMIT 1 [ RunTime:0.001258s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526682 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912410,190141,195948,699717,148483,312498,714390,231744,779493,251825,233390,94500,586279,259944,957415,539988,526345,670250,891876,135814,622525,438757,839213,8772,283815,44853,942460,201109,223341,65028,5725,509893,238922,138105,801865,610996,402812,697444,177792,427083,870257,22209,691115,584449,468933,758668,62097,211568,612328,423259,864235,634300,446871,1012693,243521,472261,616743,678480,351294,132112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526682 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526682 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]