SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 308090 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 308090 [ RunTime:0.002753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (657388,732370,777414,719218,71974,980653,649520,780540,80110,635377,898797,228460,137830,956169,4828,474916,996506,1044821,430076,435744,4164,393528,911031,711096,1010808,474547,322832,108260,695101,194344,39148,6181,1040600,313267,484928,461353,781940,368144,222522,840665,559920,479846,637284,117325,503736,873790,1004896,928227,23850,884151,490570,58261,728642,938684,908185,331952,188763,36820,76331,260421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 308090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 308090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]