SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473146 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473146 [ RunTime:0.002901s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342929,410778,793052,11916,742204,868507,580859,267816,419787,605467,646733,258288,31335,515944,789033,739882,300413,888511,544737,494045,871460,529883,596274,1008471,447737,497058,805071,336667,941852,133261,123930,447210,434809,401584,106388,920135,706429,460896,332885,537317,143342,986901,138723,966433,79273,548373,594263,234562,617045,302046,874233,61698,593775,951294,192510,768384,640404,779041,712066,586651) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473146 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473146 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]