SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 861012 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 861012 [ RunTime:0.004815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424374,765348,246374,522211,408544,206026,896413,40778,954280,557805,335258,908539,264633,333846,978313,412291,477358,1048000,266005,604175,1041524,523060,413707,53384,987546,500744,550691,116034,110413,719870,548135,190589,866431,560359,859541,880955,1030871,495851,931943,178112,751151,736667,242526,946574,263193,360997,702200,406750,374358,687386,83679,551803,423489,875238,713336,893801,602810,48873,97294,961465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 861012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000669s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 861012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]