SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504825 LIMIT 1 [ RunTime:0.000916s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504825 [ RunTime:0.002004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039060,263543,140466,508039,633102,964398,7456,859112,789044,15553,23943,484993,105975,379818,254074,443884,842402,769177,683641,827003,354697,629812,656577,112328,669038,925495,433962,660040,621999,447437,390970,208045,756531,741586,432948,123274,890758,815628,966490,465773,576911,1665,21719,270982,596173,678558,648661,98501,278340,785029,82744,496312,929289,724523,547846,153095,284127,371078,654032,821660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504825 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504825 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]