SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38578 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38578 [ RunTime:0.002674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (465515,683837,434717,455905,917990,601026,21190,236516,315586,829297,569617,630427,50156,950694,1046373,555411,114883,233797,678016,989190,341133,511200,648178,595862,941630,787759,361470,958006,100117,817233,419360,887201,208214,806674,242239,531062,706537,886744,688281,351926,545549,942118,1008799,194946,194534,960353,155282,256638,981677,54137,267987,546494,19929,544111,721092,796757,816212,761203,4101,258255) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38578 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38578 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]