SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421434 LIMIT 1 [ RunTime:0.000488s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421434 [ RunTime:0.001531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912650,1012551,438008,510647,336082,821252,119180,103755,463505,523578,542772,736714,133145,775288,576286,877200,192710,484552,545841,434223,191290,905153,658763,933393,709394,92147,1002894,706940,665305,363974,819433,124770,978493,955287,838471,780674,706806,1019260,874262,39676,680348,742034,521564,217178,264419,789698,34015,343813,959665,823377,616221,171659,555690,65761,829410,304504,967224,260325,81374,783905) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421434 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421434 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]