SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420010 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420010 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273267,425438,494173,944793,107168,995830,931454,1034046,74312,560207,269246,958961,508233,777186,282344,85911,62054,42165,626787,514223,947003,430629,403315,125032,737226,22136,879391,93732,108208,337435,1000162,76243,81070,937292,464076,205248,173652,252902,436360,212425,928920,213302,585564,370784,474529,242434,483068,842755,894057,983679,964376,1001189,429583,966430,892724,780059,754241,171016,23765,277339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]