SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001745s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47569 LIMIT 1 [ RunTime:0.002044s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47569 [ RunTime:0.004862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011256,514605,52780,665505,780346,179712,77713,810485,331608,18708,1040912,68850,176410,373770,405018,884036,757116,625391,223881,264452,469242,57375,1037626,1030112,670340,908478,585094,1004118,360319,380878,678467,123858,454738,477748,1010319,252723,892197,787963,419014,188210,371565,620488,765592,688846,713677,375560,282571,464006,807749,40265,790528,753974,641496,478728,878343,963651,72640,212621,113429,253572) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47569 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47569 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]