SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54001 LIMIT 1 [ RunTime:0.001035s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54001 [ RunTime:0.001984s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (656502,245036,860546,179685,126476,381625,1015732,492381,578208,598586,14746,922031,447341,534089,978606,52760,554750,911511,732836,740024,527964,847531,248459,871926,142753,663788,331707,127456,517596,406742,479135,744149,846492,493588,230168,680467,1016178,286127,299002,626356,740889,712683,139474,992559,287393,768551,229281,146457,746781,236110,470747,880670,68688,1019383,641418,19846,773597,878229,796383,781093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000680s ]