SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548714 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548714 [ RunTime:0.001411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (736066,753760,274224,85615,454134,853102,747588,494143,9459,634765,144621,953034,535164,20108,231800,313151,924042,546111,157100,614672,1016320,751375,419629,999748,276589,184836,714998,783666,27452,38032,961172,370696,454614,518239,509924,437539,370250,3109,537945,658484,84719,607235,677490,552594,976484,810682,473305,362596,640131,56740,561748,763930,300732,39140,87799,418759,528724,899723,934824,594280) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]