SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196882 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196882 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310762,427037,610635,118313,264224,115932,416014,669592,833013,962064,187408,326416,599360,837022,617889,703467,1023013,697310,425000,399754,535350,57737,282727,24338,361500,73896,951678,713004,894036,859603,53266,469862,257988,65999,975492,898921,710312,429550,795169,21246,295801,49624,347754,509258,108411,587133,696228,680110,777770,739563,966688,873023,340143,356172,279145,628905,270563,872290,560936,1021830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196882 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196882 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]