SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440353 LIMIT 1 [ RunTime:0.000574s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440353 [ RunTime:0.002676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137296,320837,18753,436286,379047,708110,159212,615969,724154,505629,488812,588703,826504,200569,924254,1019895,395886,247849,996906,904889,278220,150640,648313,38023,399300,678841,389104,426148,688200,597154,705572,698288,489230,764334,835518,170813,293505,232603,1009124,695959,866631,873140,1048553,400413,748655,526483,394255,719258,594255,58963,38567,543012,378026,644554,235240,409894,228145,771390,621304,74345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440353 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440353 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001157s ]