SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042217 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042217 [ RunTime:0.002131s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (646900,666038,702779,49398,608982,830279,1015693,44874,484737,810501,939320,37148,951946,699575,378441,585296,633570,543486,2236,928192,793095,42679,190788,786808,350764,1047245,546782,1046315,331690,372790,258707,855161,538334,307583,278241,320608,659286,106491,742723,545561,402031,963260,234368,624937,576453,201337,347908,692535,1048219,423935,87996,934605,335067,120650,985727,728548,835586,972204,1019683,864089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]