SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471421 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471421 [ RunTime:0.003031s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501437,564014,381980,272218,8376,1044560,206688,812662,861237,784055,744231,424756,268232,977108,323975,555882,315311,958106,978556,356973,692213,152700,356836,191123,759004,611456,909147,351026,106213,642875,494633,848084,729255,999790,802973,427171,65275,540271,409918,139742,893294,43353,573400,684591,246956,293461,917062,455362,79464,385688,138420,639131,93832,384200,819858,476187,322250,556984,383233,527959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002393s ]