SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041504 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041504 [ RunTime:0.003690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (676938,330530,986992,293480,52924,875595,976656,307510,804116,851900,923126,792920,437655,278049,840589,411239,388422,218456,363044,753344,950845,53544,536848,441998,122665,27516,890483,692272,102896,706863,584240,314665,180120,571988,494696,510620,885584,723321,1526,338318,245876,1010506,498893,695977,606594,1035810,764015,738128,288334,538090,264288,967302,595303,242766,2254,167741,603101,883131,125122,189896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002618s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]