SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427975 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427975 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (346445,482046,506662,311794,180049,758817,45034,861885,1028725,711376,19664,70850,729071,554471,357145,167649,34464,221511,486047,206130,659375,997202,446353,819054,33003,765567,348655,457243,536637,1010981,70480,813711,297203,724460,1013300,71830,17729,490961,842054,230214,884274,847452,489905,628482,404578,437851,566849,302858,835389,352146,682764,425,169591,1033912,211709,28281,672437,167562,482293,189916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000383s ]