SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523838 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523838 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480858,347455,589604,919251,353539,838623,791711,876047,251639,80565,748247,935177,240375,228169,193367,134519,979946,561327,641745,340292,544062,918276,409746,44019,781078,1046119,1031103,90041,724726,340529,418510,476401,54402,289067,9626,1003924,775483,162477,855829,170769,303515,143947,851362,221979,143557,986832,806525,765008,435396,56264,685832,1027418,54036,656021,518628,197423,258007,669964,584729,151433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]