SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004077s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266407 LIMIT 1 [ RunTime:0.007430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266407 [ RunTime:0.005308s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455827,271063,654265,510817,103889,1045785,924407,878500,714831,265024,65713,296026,801569,104948,536793,531500,509679,868872,250771,844229,173163,1042547,983417,80029,464845,302325,676164,79901,260852,429948,278869,297453,875279,660412,598705,845233,462669,532290,600655,438811,565648,655657,260348,574044,392961,343974,370963,436038,748111,253367,81662,1015777,871537,87075,127642,97364,53718,350998,350339,364883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000368s ]