SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519486 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519486 [ RunTime:0.002388s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (713689,468140,124056,775224,841917,660592,474067,876038,575996,726850,961867,648818,116150,855506,942168,740446,122116,752400,71940,587391,754661,776124,151313,623813,410340,544933,893960,126065,328246,691211,683490,479447,652176,202258,868438,958718,143429,830322,344109,824580,116716,708696,994313,1010205,768663,333615,41772,575005,681691,934779,776963,661915,473800,694142,495066,523769,330789,126801,629697,303209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519486 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000674s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519486 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]