SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482901 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482901 [ RunTime:0.001549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (184837,242118,850563,103439,587772,567065,641374,105348,470541,295102,971382,745859,956083,460404,921761,567409,1024298,427132,620249,527499,461382,496860,436580,340736,24992,252329,372641,420057,273122,268162,684363,803948,43962,802511,80087,351468,709007,121849,945470,886227,470615,201974,1022278,762603,575926,1042172,236757,356082,812678,120740,107678,576062,903969,452580,36892,726385,439570,937244,932469,1012851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]