SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 664801 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 664801 [ RunTime:0.003082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502907,383533,33896,336799,866785,63305,915338,587954,939778,602354,25525,1024619,434955,1046261,524609,66013,513009,90866,919865,332596,382303,962143,1047575,22844,329210,919192,30461,181388,876048,583609,973441,334181,458077,294216,874694,1012357,1019349,996501,299630,656242,15246,243410,618386,290216,710020,940051,779756,351335,1038818,565576,481809,833362,259503,929471,799434,384363,713261,332225,748263,685220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 664801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 664801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]