SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453890 LIMIT 1 [ RunTime:0.000558s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453890 [ RunTime:0.001920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (708623,1041613,240506,377759,917176,774082,183420,586759,568343,836709,162940,319104,631727,892074,361612,250032,115421,917390,297563,444251,318872,1037539,367662,414993,653757,916606,933761,705171,378572,901069,399905,604936,227572,591046,517503,850306,687287,493879,1011459,161957,669719,303585,426751,335041,194092,97149,972450,1036692,988760,553767,142138,307577,468204,695377,307275,597183,511792,842293,887184,713989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]