SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466014 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466014 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (874520,931543,561809,322863,283354,244774,134560,881751,171758,415178,799539,534670,673100,906411,278823,507347,749975,713255,528498,393204,922037,1029639,287679,965778,1037230,184711,839521,895427,512373,267792,970676,138562,780642,704898,735750,564649,65458,407771,76127,204597,937319,585378,382466,502528,955568,711151,140623,66099,357935,566376,538817,520911,739975,334972,728039,637273,460965,758818,184341,793514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000831s ]