SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001564s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3411 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3411 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (213518,917544,116135,1038351,184330,992365,1003331,175259,747983,52798,271436,144389,335040,875326,901911,115987,739769,446675,514903,936977,461066,177116,1011733,144451,811750,661449,23102,99974,440998,119302,327531,829131,79615,333964,264690,1006560,420919,1027818,853090,305129,232166,807713,400843,898176,799242,61074,644322,404310,1029281,1029274,116268,1001526,945605,168440,502832,899933,1003220,1008266,226109,868492) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]