SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280329 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280329 [ RunTime:0.002597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485796,873441,160591,801711,139467,367995,408060,522195,204861,545128,396120,930132,152320,440027,452663,70716,628101,488492,594817,667656,1035557,883630,198279,685399,933921,376861,798142,571364,331024,560782,81052,220202,847,527429,517123,84020,395000,545857,176373,975346,521774,652891,478471,611229,938060,133029,811065,340749,468104,261609,235397,436258,394761,651606,237748,836447,530264,625289,464826,307290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005775s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280329 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280329 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001518s ]