SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331408 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331408 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112189,591119,301944,909541,851766,354579,1017125,63997,247880,843001,696552,584817,797031,896243,555898,397793,760184,969355,122475,379142,862936,898389,230582,557512,823370,701491,586827,569417,272037,768066,998475,362599,374937,856028,501137,875974,16145,746287,1008073,875884,436600,518095,369831,258894,415759,81623,934238,566896,348631,541254,347162,255600,569580,807636,288555,774468,435858,83322,396228,686954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331408 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331408 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]