SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499555 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499555 [ RunTime:0.002781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (650025,404710,936952,64521,195976,819811,248447,249075,197665,333402,62329,206104,66299,311711,204482,314603,573886,959871,851816,524390,59812,1035329,116038,658608,449113,394507,838908,152012,372015,110080,648243,125770,247577,2083,122752,888100,478902,54114,801668,75050,428405,740535,294530,380661,140788,814285,61209,821951,156510,644812,336144,806142,739947,777251,948930,113949,659849,17128,255524,850496) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499555 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499555 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]