SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 682212 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 682212 [ RunTime:0.001857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (92225,129316,199185,562477,724068,644296,230714,162704,708424,985035,16144,437450,937017,197970,503543,897676,995645,198777,243163,989642,248573,712520,346164,133191,165807,583187,926035,686247,689509,255482,521343,908631,906232,525014,192982,662840,201128,31874,963050,488796,506691,874796,408029,584191,618989,484745,970189,451010,841429,796487,1018490,867242,663613,927871,968673,1012860,912772,866805,477351,4870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 682212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 682212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]