SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291492 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291492 [ RunTime:0.001535s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (224471,659376,1011819,474734,695080,1027574,484739,620837,423573,936464,978889,956838,946936,341880,636044,1025337,599272,707184,476664,542935,1020368,135104,205479,761814,1036231,434300,376311,203120,954195,461535,316944,748230,1013566,916224,316099,109290,336811,654280,1010917,235949,725497,411847,655257,208786,955730,868185,555150,534741,459615,496370,842073,371510,365880,116435,215444,998774,500369,421154,94926,595789) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291492 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291492 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]