SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410728 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410728 [ RunTime:0.001484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939811,555319,92013,580379,904977,314790,651113,915528,724318,914024,293538,432373,206648,899413,39566,467020,292090,676072,700406,11900,494730,123510,861371,217788,612030,516508,196047,536295,589680,601998,5939,797322,568899,401493,725173,672312,81158,375065,120046,431092,165801,429056,753124,543729,1007497,141752,551144,309909,108314,536796,915200,761054,373028,673996,850089,609329,793166,484642,529066,733110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]