SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506203 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506203 [ RunTime:0.002031s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (605656,509777,836835,968119,41652,14129,740184,818969,648777,307780,616208,193316,645289,945059,748459,1014209,907837,897136,434120,726747,954183,105706,464827,677235,1029418,265115,814870,17731,143443,360530,713269,927016,189728,464560,323858,578851,985869,183232,461317,118962,612586,114966,991308,187969,514164,618033,690407,555524,611485,50153,284956,483021,55798,986359,675353,18292,600272,742339,492559,592649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]