SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043930 LIMIT 1 [ RunTime:0.000285s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043930 [ RunTime:0.004261s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (490062,126085,652625,136721,439740,221658,626037,118184,972556,601,439564,6212,315650,17972,876354,1043949,690580,994949,287755,440458,329634,767132,81078,22623,698153,711972,880648,632090,551747,551578,575191,723283,55659,306983,240231,719293,304596,677234,867366,898031,687928,202739,23672,595339,414501,470474,871666,337452,757041,419022,453512,376789,585134,74233,193813,312751,847336,215256,438684,146550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043930 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043930 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]