SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54394 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54394 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (162696,462602,6169,900819,26493,1002289,591427,473821,557163,809415,218948,511813,912703,264275,893491,51166,184852,658364,15208,980892,416434,1037210,599706,174118,593441,875720,399517,587216,1008328,431710,557671,630873,527845,916937,950257,734615,916727,504701,140391,445883,447462,376172,509886,633850,670001,95589,825222,848222,505432,927421,1026819,832872,324092,865271,201034,654549,817195,237579,970064,528788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54394 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54394 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]