SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 170417 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 170417 [ RunTime:0.001450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24957,523352,1041250,988834,402574,743744,900026,335385,311600,475306,583598,1031539,440763,149485,212124,883773,786968,443046,280946,842495,677374,1043218,777919,734331,698549,136411,845232,969850,187342,106206,976657,627518,242371,547750,782182,902845,251262,186217,1004421,1027398,892613,323109,815918,32473,975590,730118,957289,575804,662469,554601,642896,818110,594921,341937,818427,139244,772888,943492,53463,249912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 170417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 170417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]