SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002020s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154200 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154200 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300323,729138,724552,110642,589835,412330,311794,363397,140317,120315,698379,229048,873900,80727,501409,945579,767523,148279,354472,1846,577712,1024779,164006,841744,866879,629425,653783,852958,747374,621552,718477,936935,100042,25138,132573,663711,574935,126501,431617,233161,197503,860558,822202,360979,587579,581286,207161,81648,613740,963040,102876,126281,1013600,18546,648174,633611,154843,969609,92784,620663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]