SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495244 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495244 [ RunTime:0.002854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514019,579258,761010,308913,821253,161344,827090,618762,993491,769928,619053,1011811,376587,1026473,260818,823390,618192,692947,100091,266322,329720,444097,267259,821113,411166,313539,45829,656683,801896,859529,289935,95315,587912,537838,461920,1020348,261368,506901,506511,319180,651150,483914,939444,710614,914024,802618,161654,537044,492635,726262,419921,343736,266810,428480,182779,837820,235541,764491,322222,787276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495244 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495244 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]