SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001681s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450188 LIMIT 1 [ RunTime:0.002123s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450188 [ RunTime:0.002199s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (929525,718559,167253,395499,13742,340097,141485,766334,451611,925475,421235,524685,34574,634330,556177,922389,587575,1423,920412,606402,432713,666857,1031726,443130,989502,854244,657390,662526,34856,254305,565809,911900,698487,815235,91510,585109,237383,373092,914222,953568,1012073,235649,797073,582673,404622,608768,291688,447250,609751,127735,719711,434134,807439,1016178,121447,193311,723479,1026003,28704,993528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]