SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039243 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039243 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12047,349990,207142,543151,304141,622062,365587,357320,455321,403134,877323,215682,189230,826354,467382,953557,41783,700148,129504,880708,948780,278559,466073,763249,885428,858684,811468,544089,479936,817094,30661,623119,106701,536519,126637,410513,829273,308270,966455,213587,725075,187786,216973,334686,300359,700668,1009287,776477,661280,888128,491392,699811,560521,476637,970847,59532,613140,621528,137320,530342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]