SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300406 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300406 [ RunTime:0.002428s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (177526,837010,1026157,1043869,865479,1012166,1021398,308709,486554,956953,490660,619595,898791,707970,911863,573085,691267,1010844,777949,838513,789672,293738,987800,598176,504642,453763,388999,717851,405757,393298,75377,951148,524216,733461,833869,196527,337348,820268,802496,318045,140215,871710,1043745,239074,428499,674685,304260,642443,194534,368530,759621,733701,309419,119118,57481,846721,315500,240836,176431,738658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001655s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300406 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300406 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]