SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 26573 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 26573 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120274,37397,677535,1009893,1038525,196687,19096,623323,859099,619090,512720,277389,93788,831545,225860,120224,630925,163548,811478,991479,288549,113304,108775,75062,74280,499358,86336,459221,753034,225131,949420,923892,1032531,177935,717403,84339,431236,548687,837221,494282,1047106,326445,795822,1001640,897904,401898,1017774,643828,17868,790955,163779,336635,602032,127691,662587,826565,535754,147234,635361,961377) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 26573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 26573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]