SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 820883 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 820883 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411831,292790,108854,182345,539851,111271,91264,1018410,395730,19562,596007,105623,147770,615100,959695,364836,350684,462653,118354,230165,827700,38937,195627,202353,500118,683373,725907,533541,1014317,206852,25563,818083,28946,599850,873045,941025,683967,366962,410963,482633,212373,630564,979369,402394,749937,699858,479882,130585,713054,821118,571775,509951,40193,427194,657487,337498,971421,486370,510614,382697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 820883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 820883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000691s ]