SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003013s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505343 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505343 [ RunTime:0.001704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920994,105291,11455,966027,19231,487272,380140,910478,572559,857637,201848,340924,346314,270264,168465,687214,648202,586758,168058,534955,854933,1039276,65266,673393,601750,504221,764606,995088,70060,29492,198719,15978,680449,630195,556049,414899,126991,510126,268095,196678,875695,687650,779273,656527,1047523,188456,597617,559421,670148,574951,529508,898420,39883,549664,161284,50142,219914,407034,225424,932250) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000797s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]