SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034199 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034199 [ RunTime:0.002220s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493930,700128,918301,296109,776719,911079,450570,490526,815927,420503,502048,314810,621113,370924,184258,919649,161272,503713,864443,626385,29677,116074,182770,993280,289092,475981,674785,68397,632642,519026,221190,115842,321335,123448,20583,20818,65049,868954,299621,210365,776478,119483,259569,300626,949811,384812,398132,204145,281614,142775,471054,1000953,115275,304690,285986,486836,174752,727249,533977,5377) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000364s ]