SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531527 LIMIT 1 [ RunTime:0.001423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531527 [ RunTime:0.002705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (901922,224791,619954,76930,841524,246529,757729,255309,2632,572726,165897,523298,495841,454056,34574,435514,1039935,380037,280249,819499,715192,536352,907002,991964,998932,272142,757818,708451,226265,841983,674297,976714,547951,223780,904091,826726,1022415,612590,527429,480548,69494,811746,284249,1010537,145814,231485,697303,749293,749541,523992,263648,874821,810136,875276,636995,221814,274133,1014316,926967,45483) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531527 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531527 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]