SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266265 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266265 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020041,906813,341484,374817,362121,280323,749878,815519,682890,341701,988903,566180,861045,215892,606794,197217,578210,313469,151658,444898,134573,87067,846728,855182,277545,444501,169131,630433,513610,806166,992532,142875,1019494,640446,136117,818427,541759,343902,364174,125617,327695,147383,451055,890651,409822,397745,122223,72144,979740,983140,630114,920437,185110,580891,128646,11417,463520,13027,711645,45561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266265 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266265 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]